Excel 2019 - Expert - Lookup, MATCH and INDEX Functions
      This course is part of the MOS exam 77-728 range that will teach you the essential skills to successfully pass the Microsoft Office Specialist (MOS) Expert certification exam.      
      Lookup Functions      
      Upon successful completion you will be able to:

1. Use VLOOKUP Functions;
2. Create Lookup Tables;
3. Insert Functions;
4. Add VLOOKUP Arguments;
5. Use LOOKUP Functions;
6. Modify Lookup Data;
7. Use HLOOKUP Functions.
      
      MATCH and INDEX Functions      
      Upon successful completion you will be able to:

1. Enter Validation Rules;
2. Use MATCH Functions;
3. Use INDEX Functions;
4. Nest Functions.		      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2019 - Expert - Lookup, MATCH and INDEX Functions :
Program Training Courses - Microsoft Excel Expert 2019 :
Office Suite Training Courses - Microsoft Office 2019 / Office 365 :
© 2020 Online Training Masters